Hi,

I realize many people may have faced this problem earlier. I have searched through online problems list (including two in this forum), but have been unsuccessful to find a solution to my problem; I would really appreciate if someone can help.

I am trying to connect from PERL to a mySQL database.

My Perl script has the following:
"...
.
.

use DBI;
$user="root";
$password="";
$dsn = "dbi:mysql:dmtmp:ausdhcp92-128:3306";

#making a connection to the database
$db = DBI->connect($dsn, $user, $password) or die "Can't connect to the DB: $DBI::errstr\n";


.
..
..."

However, with this, I get the following message on my console when I try and run this script:

DBI->connect(dmtmp:ausdhcp92-128:3306) failed: Lost connection to MySQL server during query at dmtest.pl line 33
Can't connect to the DB: Lost connection to MySQL server during query

(my perl file's name is dmtest.pl)

I have tried many variations of my DB connect request, including the following:

1) $db = Mysql->connect($host, $database, $user, $password);

where
$host="ausdhcp92-128";
$database="dmtmp";

2) db = DBI->connect("DBI:mysql:host=$host:database=$database", $user, $password);

Those have not worked out either.

I'd really appreciate if someone can help.

Thanks.